create procedure [dbo].[BAEImisActivityGetAllByUserIdActivityTypeDate] @UserId as
varchar(10),
    @ActivityType    AS    varchar(10),
    @StartDate     AS    DateTime,
    @EndDate    AS    DateTime
AS
    SELECT * FROM Activity
    WHERE ID = @UserId AND ACTIVITY_TYPE = @ActivityType AND TRANSACTION_DATE BETWEEN @StartDate AND @EndDate
    ORDER BY SEQN DESC

GO